CREATE OR REPLACE PACKAGE "kesplus_platform"."search_model" AUTHID CURRENT_USER AS
    function getConditionSql(jsonData varchar, conditions json) return varchar;
    /**
     * 拼接操作符 与 参数值
     */
    function resolveOperateValue(queryType varchar, paramValue varchar) return varchar;
    /**
     * 处理 in / not in sql
     */
    function resolveIn(paramValue varchar) return varchar;
    /**
     * 处理 between
     */
    function resolveBetween(paramValue varchar) return varchar;
    /**
     * 处理blurry 字段,如果为,则切分,否则直接拼接
     */
    function resolveBlurry(blurry varchar, operateValue varchar) return varchar;
end;

CREATE OR REPLACE PACKAGE BODY "kesplus_platform"."search_model" AS WRAPPED
iBnAwqJj3m8/gdc4DRzeiaHHtlCGsb/nTvpF4PurV/hvhefZ6GgRuuvLUD6j
kWiLT6CyMz8wjdcuHfdNBy01e8VT0o8Ng50YUvZ6eJUaqDWadF5zqYRDv91m
sxoHQ81dzmjRsCzk7Qf2flIFdGY2Pn62hYQKjrw2IaDV7U8Ciuf5a44x7ZWc
XsHFmhsu72PkSoo+V7PgGtOjmXPE/MJdAMcNMJYIYg/BBoyU5wbX3fkYHaFt
Iyd2JqJXuqEpnU9nDjC4PebITj+/7XiiqyEUBNMEbE7HSu6vNt6fqm0hxmhl
JfUfaB9+n9RMeOBthXWAZWAIUfrSv1dEn9JevRgPGbgE4T3u5uVZtOLgYeug
fH79wwhYkzzJJwNDPg6ltbLgenNvRleekJJjO5XRlp6gio1YwZsrdC3EzrKa
hZydtd7S2lKPds5W1vkK3Zn7SSdcZbOGFX+CdVFHTCxPP/3YxW0B+QiYGtEW
FHT5vlF4bvY7jdMFUVLyBE/74TVQ3TzY+c65VAlrFjvqA8i4y5qCzRCSq280
wnwwmPKU+ZaaSPRDrHeanQi0M9VOTIYyeu9dynzJ5xRreHX9geOTchGvmv4J
VC/5WKtgcJ3TB0QmQHl+Fw/Z720+2Ly9wI+Z7F4H0HjCA6zJ9s5l89j8LaSH
D8CpcC6nybfwCiedv6DYdSWkRP46W19CYFkH802tLd5yvSczP4yIeOBSxHGe
aFJY+0ESAuogG3xJgv5PE1jyOIfMG8WhGMRCprOZtJRUN4hiOCNRP9mkjcdK
yP9tL5nqf30JgBid0ku6mVdgSbiwQSnjn1Lp08LFphWHWIytMDhWqLVjgxYN
4bXyoWu8F+SEPe0/O3Fj8qQvLuuOy/ZWu8Zv9E6rPSFas0Zfs0nbgqfDOCgB
9aPVU0pHzSKeYYUgHPUZ88tzDASwEiVDLSpMEZPp68MHLWlTPjKxP6sd5PHp
3zER4CrZnYKMWT9NZ34hRyU5W817EGs5rt88+CPC0J7p68MHLWlTPjKxP6sd
5PHpn5AKYQhSVO1iW2U1TlcVd3esazZauOq1Cm2+6vkFnjhE0ES+Xo/Xsjzp
CNR+Vzi4IWYag7JbDIpLHjP0lV8yuzkVxtGjGXJ9bzQ9fcsPKuRPgp12RoU+
a6jvRQ0QC7aWBlfEUib6QZTCzPCqzA83H7aIDv5UG18G18TG1i+vCAsg0Hs3
lBG8heyj+qJ5+S581eJoC7g+gbdLJrdQst8wDOMenmvG7q1S+/I9s4kfo762
Fkkp9hmvskH4NAANZhreVzzCdclhS2sS6G2Eu2d50wSWAfo8yorbonNIxNdq
B8ZOIq3btktmJRo+QCmTjmjyS5t/ysYH9nsOntCqU9J2qSIC4IJH3RVFQHr/
O4wlcEjxcfg0S+3cz8VOg134WraoMfC3jktHzfT9pOsfPQN3aXS14ZA3shAB
VdHJodE66cPDHn/dEPVPLAfq1LEBzVHjry1kSMPBGv5xIOkhcLEHjlAlJV2s
ZpDRpXeN/JBa2WH6FXkcga6fAPAALEk3GgSAv+yNWZuE3r9yInowPjHOczCB
gZKeaUD/P5/FSsUnOASjIWljk4PJ7CvH7D1UkkmaFDefmh/NgcWlaHuzbz+v
cDqVufXtNgVgKKQu9wDau4XPqQ427YJJmGJjXwSrKCF/xzhB++wfJFfBDUug
+jzXCbAuj4YstQccGInlbezp83leWN5DugKW/9vD5YaWR77L+Y11+HIOP4ow
XsnKSwLRwe36oV8MGl0N+b1s5wXOsapA5icP0tn83YPpMZ6ssvLuo4qKlzjW
djDfyn1CeFqyEyl67CfWd4VoVdBg3mQj2rKFeGkytW5oJfZKpQEMKwX3sIgj
ZLuv01rCxWdnbpbmzCyuOVNPSGugOz85z1kn6s5YEwmonGhHE+EooFjv8Zia
Dp4H81I3jQ4Q6Tz9IxGb/sQ9bCA79fBDLAy6BHPCUPWq3zsn7vR1u1/YkSRE
0hk4LnPyPZ2E8i7qoe7j3f6j7uX55Ad49nqI0WXLQ5Bz4T4SfFtn6eX41M0+
E2CPIw/vSClXVTCr2oUNGtG4Rn4GsLrJP48NtBnYHa1MMbBAgZFUU4c3wQKN
CK1s+e7mSaSzwuTzIdHuFB5c6zDcdXCo3yeZjk7EjZGROUvtbD1SHdkIRsL2
CvmsSUpGSqowm8U0PeLNobcRA+4oOgKYe7Mx0vL/kY4jvn+4LkWeTBYbFb6K
67+1lfX6eZ9fozDGYijbiDAM11a9KdQWEUjSBV34voX8HGZKfd7Oz+L6Yy2/
iQcr/HPzcvdKl0bxIQ4TS/Ld8OL2WvPee2TmIB5PynONwiqSvlb14LMZzxLu
I5rfJhGLS354DFzN7xJcqOoMVuERn1VChj8k95SQjBl0lQR96zCuTet7wRhT
hiB7A6i8sPFUFJ+pnMcj1s+Uh9XknDxxKPQDfqHLtpnOgw3USjnva2v4/o/1
nGiFyubYmvth9mng42PuDP/f0bpiQFxVeCeDDOI/4R1QbYuHkl9kypxl/gUJ
tYVkTYp0C/CGImI1UHAD4TKJOrM0m+sZ43BX7XHQ/bmi5q6jYUCzeGQHCbf8
fGQFiJXBAqbxWA8vN3gbPkSn3cjOUE8mNeawH1N+Kvp7/oWYt43DopLT6KRO
MuXlu10GHcb78u0SKYXs1WPSXL82HtX/+beyidG4EfSqVOTswEtUy6v12oqy
Kl0Cw8eDtjBScPfrJBLKjJ5V1jzDGMC0PhXgfJWV0WwEL4M7RHfUt5BYTIlO
VqYJ2MB1At9YeWmcb+unkZLczj7TXK2nSuIV3v+drGE8vCPbZaqhiL3I1l8U
m6Td5wxTmOysfdwQugUJtYVkTYp0C/CGImI1UHBDCDHjCrxGmdCa/9cPjzZG
K/xz83L3SpdG8SEOE0vy3fDi9lrz3ntk5iAeT8pzjcKn3cjOUE8mNeawH1N+
Kvp7/oWYt43DopLT6KROMuXlu10GHcb78u0SKYXs1WPSXL82MVK6XhhyO7Yw
P3LEc163wuTzIdHuFB5c6zDcdXCo3yEZfBIkrVWcAotqzCmshSkIRsL2Cvms
SUpGSqowm8U0PeLNobcRA+4oOgKYe7Mx0oZrkqU+CHJsaF1xB1IDVEFEFk+d
nX2IWWq80Td7HW2wZAWIlcECpvFYDy83eBs+RP53OJFd+ZnshK8H8TnCo/L9
uaLmrqNhQLN4ZAcJt/x8ZAWIlcECpvFYDy83eBs+RPExRrWdMRoCpPLJVfHm
oMKCzznklho4elAXgwgvSwURS4GVes8rL90VdYJxznGpNEAfdkBZsqXJoujA
EewWuF6y7uUgvb0oJQYUwwtvLhXBw5AfTBgerF1tCTHR0K6HRHkAdiGPxwkI
I16CozUosDn11o5E57L18qoXZalCFsZH7woDAzp2ukqK/oAZ+qRg9ZiMVPyJ
99JqvWRGM5JGgAzajjHlaTJQ/cbu5e4atlDXvCLBU0aGKZbVo3wsrKtBmpan
XiIAws91tX0seyvhjSQsrjlTT0hroDs/Oc9ZJ+rOa/j+j/WcaIXK5tia+2H2
aUb5q2RZ+Kh4yHZXoG6MNqWuqMUWSEi3vtkKegnxnKO+WyhgxdOxcqaUpwMs
wLkt2whGwvYK+axJSkZKqjCbxTR6VH+XDKMuENRtdRb6yKOB+888GGwoARED
nX9kOqVGv/7pjlB4eB9iAHOrmqLW62YJJqgNBlWgsbIQE9Qpi5tRBXDL/4zL
IMmvDdXbkBAXAK15oOoKWA0/59S5CY3Qv3ZbdgxBSNBFlBkyWiVj4iIUApRp
/iDr1tN5Kf3KzAm9Z/H+YlOrfAPnR4OG4BYSFGr2AE8ePo4kCvCTHK2ZzslG
JlI9Cjar9IqJf+kpr6tRhE1GDMKl7fNAQpD+79Pj7thLgZV6zysv3RV1gnHO
cak0fBsIz/FKAEi6GRJAyYevjv5biBZs1NszPSUpaUJ64OvfnlBpSrsVv/ph
bCh0kut4kzibQyMhFhF6eNyhiP5SwtgmxbevFkSKzxnC+9xA527lkkT2J1pf
G32iqHga4bB218ADCHNlij7STqbjAEcKzNovFTtn19R5jxGqS31I4kw1O8K/
keZ3k2XDMdYCj1P9PtJt25KebHBbk+98tJhZ8BNY3DyUszbnWJ1tMlgdBEKT
0Mr1s0iC8v/aN8uYWwGjjDeuXpJ8mRDA+PLmfFLgtb3bI99n0UPWp7EGFOsJ
AM7HNEBl4wPiUmotuxOQAf15zweSYenn4CPFUycZIS9YLMWbxcc/voghytYL
sn5zZWiXgCN7031F+xcGY86DhqmJjaB6sgztPZamfxp1SL5gUrslxyrVph6c
rrUBG+yMEePdgw30TEDWr8RY1srqJcE/JYgmSj4amDQeMCzAA7+0qAaAE0tW
a/VQ5sTyzunA5iI8bzCum8Va3YyzMgcyfOz1YHKSdvs5HiFW89UoejgUUBur
Wl+Yw7SFKzu9c2g4bclOCAwKeiTwEozNCs+zon1UtdnFM6VOwUPqYvB2JQZI
n/527MC15G/47xt3Wf3xSVhpfchfo6QqJsuqiPW6IvwbFphm63EWl/vTxKeK
r4D894bmgguPqEcuitVRq8UwV/hgcpJ2+zkeIVbz1Sh6OBRQ/yrtrwa0rQkh
vn6Irl7OQiV7DBpaQxPTkV/i3jBqD2UizleLONgp0FmmNAlhmHIbgtC3Hx8F
XPwQi1gGaz9iECGdPJM960TNRCBP2qzvUEelsG0UejXMXUPTEeeVSYzTdvkY
QeoFtklCAcT3s6+APwEdESWzlYhuxQ/nky7yteQNjs/DNiQDYW/Whvh+QKj+
J7eDKLn9nBUcW2tTUB+oO3ojVPXa8SI8IeN9McJccB9EbsTauTZhuHO2kdY7
VOg/PIY1PPaXzgpOBHXrDCUPJ11DiiZFKbpgD37PM+kyC0NJB/lDNlSl13yI
+sZZ+4HIjPtfMutzjJmvF+NekEGwgyTIaSGULKnNmhObQBFlpGgpeuwn1neF
aFXQYN5kI9qy/SUCaqzK7diSbC7WzIsAw3AcSuqaXK4QMUqjyf9Q2UKnPfL2
VbFnogzRdPrA41C4fpMtucsLbnqGvHgt66wSK/M+XvtE2Q6PZhk1dj8WDNgW
BslvXnUZ2LAzWDaafcfTsLTW93NgZ7paurj1dBU7sFKA+AACCrdzrQvTtysW
V5BwSerplG9nTmfmab0OaGgC33EGD6o5okqZ16bbiW6GG3UIEJ3JVBJiNJy4
9KtKPJAukU6alcL1o+CKfcR3VrVqW2gVW8sOY4AJlEj3VL7aUsC6bvnTii6w
V3LTjhPpohzwxvOrhCgT2hJEnn/SpfV+bS4dbFtZIA11z/ITA7ohqMX44Is9
yTuJ0XOsmPifFZQkQhxiZcpY9Qn7YQ8wCc/7ZxHDU7fGI7a1YJhKThcgqKHS
v3KW+iP0SAwf1DItxl+UZmxFxxX5Gm4O7x8PGtL8bsB97soVO8p3GKrGvExM
6gLrRW3zJb0H6bNkIeDiRmhi1WuWTJCdikIToWTBuFmb7tY+/dhe1p1GpGXx
IDeL7aArIOLMq3Z6u5D59foXoxDT8jbkSRBkIZrBwwIQuP26BkBWR2WNlE6M
DQjLUltTzI6ThnkvPV803iN3ox2GSX7we4XMp8SQrmhn+QZmUvf2SR4NZ1yc
0s8ej0a27D9KcQeaM4JuNW/w9As+DdGd5r5qe/NaEJK29yKkI1M+JWRYwLYO
TZ5f6zJYwefnrfsZfLQm8h64kerfu4PwDBSBjnH6DI6z8DttDbOW4gguNs+C
zjmRC97RvsnKXbQbI+N0F8PDViJxC965gPCgET6MXMt9sSWD/aOQM/4oMmPT
gE3kiyZ+lhk3zhnJnMp9W6fcPsHh3p0hnZc0ce44fbwrhaeUMagtBqTG2WkF
XFRwN/GnAK0JgOGcr/a/7GrtDJbJiqrOIVcHrE0JonN48mz6Y+lFTyKTCcVs
M8Zrtt/oJps6TvyBq8c4s44Mcbb8oqfIPy8BNidazrPcRU2ij0v4qUTB+lmL
T2RrVCVfuF/ZLh0VCpBfZTv5bHOiCDOKWQeFESsX3XWmwjF47F+scq7ncGgQ
Yd+mkLyUb4DqY/fGTtstayTrM3c3NJlxEFvJrhC6E3HQ9WhQdcfVOzpoLyK6
9f/RLHTYUmOzGAZ3gs8yzPLAXUTLz+BAGCyoQSLdl22dZMlN+i0mRRnSTmVY
QU6idRByuduiFdOnxYWiG5bps/Jz0xQjw1brodJcPYiZAugZZ2kd3fAzY7Xz
C92hkWlGytdQOnCpGY1ZCk2/PzwTRS7uUpLJZSYbn8UOgh9qjWASZdZFTk3G
OfEfqIeZZBV6pCI/oUbXR7FZ9Lw3P7nVtIpJHBiSw+5UhRdsVv1zk6ko3WfY
sezbyZP53TpTVCAoPv9ZSmklGcJXYOF1X0HPHOfoE7sniyYQKFcQ/42kZtBn
nKshPKYcB2faqylWevD4HrUeGPohLwmKUvEe4/I2pzviuk5VYYKQHxaCMmSm
lpVJGzaFfMrN1O4ROYTdpz0FNx3bkgK1AWb28l5myGbNx6EiKF7X/7AUi1sL
r2gEYEPc74X01jOO29loKbEtBncwbv7MMfodzMpFvtSGsT3RktsJ15N2BkVO
MCpCHbpBGo3+EsX44Is9yTuJ0XOsmPifFZQZnlhV4+4dPSjpZ/CGUENkE0iZ
Sfio0p0or7imh6w0GN4mmhednZI65g4bzgPOvP0kAsH0nrmud4Smr9IOdOK5
XxtYkeGVy1mbUErConEwzrNmQunvTjkY6uDFkcvAWnl5br2S2G3yMu0z4Tl0
wvfHJ/Qz8Oumq+F0Ox8gxn8bImqLVtGEdTWM/l5wDMcdvyZuJlYgbuiqZVlQ
hLUxZxaTi5FoW3Fbu8n8K5CoYE/BLZE81QDKss4QA0Qjk+Oc+dxlNz37DZbb
lPxAFZ9x0EYhnqzVuV9CbpE6EnNuLuvUdxJYgtiL6WBhWxhRJZMyJQ2rR2eX
QoGSKkxeZtpGr4Bz0kI4XVeZCMJvq7lL/Hvuw3mUafMTE8lQgxOW7qsV5H39
oH3Kta6V2FEG5r70Ako6bjaJjW+yyLBoUKMxv3lmjYqduZfWjR2XX3hoV27a
5sSPRrs0XTFoE2FEsoKKlcLxSXfeFB525HaXACyZQtpsVMwr3YhpaUqgQyDm
PBaOgdfbDzbUpfSHx8WjllYnMDY9PSMvk6HXjMNWZvlFY8qKB4HfIb1xHvNK
oX14NTGkflzhzTh4DvkrXil9XzoOO4nJv2Z+QgMqxML9RRtr2InyAGByknb7
OR4hVvPVKHo4FFAq72u4Y4VlscRIOb2abt3H29aBVpMTn7j6znrFtBBbe/9l
D6zY04wJaGDQ4Re9bl0jmQAwkFdBHpczxNJI3oUYKOcHxEo/GP3DEbl4djBn
J9dr3xnVbkWEqC3D+xPNfDFdacnCPPKKpYFjMLvmUV/G
END;

